<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="LogDataSet" targetNamespace="http://tempuri.org/LogDataSet.xsd" xmlns:mstns="http://tempuri.org/LogDataSet.xsd" xmlns="http://tempuri.org/LogDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ResaDataSecConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="ResaDataSecConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ResaDataSecConnectionString.ConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="user_detailTableAdapter" GeneratorDataComponentClassName="user_detailTableAdapter" Name="user_detail" UserDataComponentName="user_detailTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ResaDataSecConnectionString (Web.config)" DbObjectName="dbo.user_detail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[user_detail] WHERE (([user_id] = @Original_user_id) AND ((@IsNull_user_pwd = 1 AND [user_pwd] IS NULL) OR ([user_pwd] = @Original_user_pwd)) AND ((@IsNull_user_droit = 1 AND [user_droit] IS NULL) OR ([user_droit] = @Original_user_droit)) AND ((@IsNull_user_type = 1 AND [user_type] IS NULL) OR ([user_type] = @Original_user_type)) AND ((@IsNull_user_SAMUref = 1 AND [user_SAMUref] IS NULL) OR ([user_SAMUref] = @Original_user_SAMUref)) AND ((@IsNull_user_nom = 1 AND [user_nom] IS NULL) OR ([user_nom] = @Original_user_nom)) AND ((@IsNull_user_prenom = 1 AND [user_prenom] IS NULL) OR ([user_prenom] = @Original_user_prenom)) AND ((@IsNull_user_adresse = 1 AND [user_adresse] IS NULL) OR ([user_adresse] = @Original_user_adresse)) AND ((@IsNull_user_cp = 1 AND [user_cp] IS NULL) OR ([user_cp] = @Original_user_cp)) AND ((@IsNull_user_commune = 1 AND [user_commune] IS NULL) OR ([user_commune] = @Original_user_commune)) AND ((@IsNull_user_utmx = 1 AND [user_utmx] IS NULL) OR ([user_utmx] = @Original_user_utmx)) AND ((@IsNull_user_utmy = 1 AND [user_utmy] IS NULL) OR ([user_utmy] = @Original_user_utmy)) AND ((@IsNull_user_tel = 1 AND [user_tel] IS NULL) OR ([user_tel] = @Original_user_tel)) AND ((@IsNull_user_mail = 1 AND [user_mail] IS NULL) OR ([user_mail] = @Original_user_mail)) AND ((@IsNull_user_videoid = 1 AND [user_videoid] IS NULL) OR ([user_videoid] = @Original_user_videoid)) AND ((@IsNull_user_rem = 1 AND [user_rem] IS NULL) OR ([user_rem] = @Original_user_rem)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_pwd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_pwd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_pwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_pwd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_droit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_droit" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_droit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_droit" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_type" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_type" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_SAMUref" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_SAMUref" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_SAMUref" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_SAMUref" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_nom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_nom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_nom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_nom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_prenom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_prenom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_prenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_prenom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_adresse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_adresse" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_adresse" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_adresse" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_cp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_cp" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_cp" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_cp" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_commune" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_commune" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_commune" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_commune" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_utmx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_utmx" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_utmx" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_utmx" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_utmy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_utmy" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_utmy" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_utmy" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_tel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_tel" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_tel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_tel" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_mail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_mail" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_mail" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_videoid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_videoid" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_videoid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_videoid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_rem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_rem" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_rem" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_rem" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[user_detail] ([user_id], [user_pwd], [user_droit], [user_type], [user_SAMUref], [user_nom], [user_prenom], [user_adresse], [user_cp], [user_commune], [user_utmx], [user_utmy], [user_tel], [user_mail], [user_videoid], [user_rem]) VALUES (@user_id, @user_pwd, @user_droit, @user_type, @user_SAMUref, @user_nom, @user_prenom, @user_adresse, @user_cp, @user_commune, @user_utmx, @user_utmy, @user_tel, @user_mail, @user_videoid, @user_rem)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_pwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_pwd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_droit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_droit" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_SAMUref" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_SAMUref" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_nom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_nom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_prenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_prenom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_adresse" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_adresse" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_cp" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_cp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_commune" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_commune" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_utmx" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_utmx" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_utmy" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_utmy" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_tel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_tel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_mail" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_videoid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_videoid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_rem" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_rem" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT user_id, user_pwd, user_droit, user_type, user_SAMUref, user_nom, user_prenom, user_adresse, user_cp, user_commune, user_utmx, user_utmy, user_tel, user_mail, user_videoid, user_rem FROM dbo.user_detail</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[user_detail] SET [user_id] = @user_id, [user_pwd] = @user_pwd, [user_droit] = @user_droit, [user_type] = @user_type, [user_SAMUref] = @user_SAMUref, [user_nom] = @user_nom, [user_prenom] = @user_prenom, [user_adresse] = @user_adresse, [user_cp] = @user_cp, [user_commune] = @user_commune, [user_utmx] = @user_utmx, [user_utmy] = @user_utmy, [user_tel] = @user_tel, [user_mail] = @user_mail, [user_videoid] = @user_videoid, [user_rem] = @user_rem WHERE (([user_id] = @Original_user_id) AND ((@IsNull_user_pwd = 1 AND [user_pwd] IS NULL) OR ([user_pwd] = @Original_user_pwd)) AND ((@IsNull_user_droit = 1 AND [user_droit] IS NULL) OR ([user_droit] = @Original_user_droit)) AND ((@IsNull_user_type = 1 AND [user_type] IS NULL) OR ([user_type] = @Original_user_type)) AND ((@IsNull_user_SAMUref = 1 AND [user_SAMUref] IS NULL) OR ([user_SAMUref] = @Original_user_SAMUref)) AND ((@IsNull_user_nom = 1 AND [user_nom] IS NULL) OR ([user_nom] = @Original_user_nom)) AND ((@IsNull_user_prenom = 1 AND [user_prenom] IS NULL) OR ([user_prenom] = @Original_user_prenom)) AND ((@IsNull_user_adresse = 1 AND [user_adresse] IS NULL) OR ([user_adresse] = @Original_user_adresse)) AND ((@IsNull_user_cp = 1 AND [user_cp] IS NULL) OR ([user_cp] = @Original_user_cp)) AND ((@IsNull_user_commune = 1 AND [user_commune] IS NULL) OR ([user_commune] = @Original_user_commune)) AND ((@IsNull_user_utmx = 1 AND [user_utmx] IS NULL) OR ([user_utmx] = @Original_user_utmx)) AND ((@IsNull_user_utmy = 1 AND [user_utmy] IS NULL) OR ([user_utmy] = @Original_user_utmy)) AND ((@IsNull_user_tel = 1 AND [user_tel] IS NULL) OR ([user_tel] = @Original_user_tel)) AND ((@IsNull_user_mail = 1 AND [user_mail] IS NULL) OR ([user_mail] = @Original_user_mail)) AND ((@IsNull_user_videoid = 1 AND [user_videoid] IS NULL) OR ([user_videoid] = @Original_user_videoid)) AND ((@IsNull_user_rem = 1 AND [user_rem] IS NULL) OR ([user_rem] = @Original_user_rem)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_pwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_pwd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_droit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_droit" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_SAMUref" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_SAMUref" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_nom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_nom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_prenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_prenom" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_adresse" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_adresse" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_cp" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_cp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_commune" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_commune" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_utmx" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_utmx" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_utmy" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_utmy" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_tel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_tel" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_mail" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_videoid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_videoid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_rem" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_rem" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_pwd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_pwd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_pwd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_pwd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_droit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_droit" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_droit" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_droit" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_type" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_type" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_SAMUref" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_SAMUref" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_SAMUref" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_SAMUref" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_nom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_nom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_nom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_nom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_prenom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_prenom" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_prenom" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_prenom" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_adresse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_adresse" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_adresse" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_adresse" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_cp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_cp" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_cp" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_cp" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_commune" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_commune" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_commune" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_commune" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_utmx" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_utmx" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_utmx" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_utmx" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_utmy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_utmy" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_utmy" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_utmy" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_tel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_tel" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_tel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_tel" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_mail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_mail" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_mail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_mail" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_videoid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_videoid" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_videoid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_videoid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_rem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_rem" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_rem" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_rem" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="user_id" DataSetColumn="user_id" />
              <Mapping SourceColumn="user_pwd" DataSetColumn="user_pwd" />
              <Mapping SourceColumn="user_droit" DataSetColumn="user_droit" />
              <Mapping SourceColumn="user_type" DataSetColumn="user_type" />
              <Mapping SourceColumn="user_SAMUref" DataSetColumn="user_SAMUref" />
              <Mapping SourceColumn="user_nom" DataSetColumn="user_nom" />
              <Mapping SourceColumn="user_prenom" DataSetColumn="user_prenom" />
              <Mapping SourceColumn="user_adresse" DataSetColumn="user_adresse" />
              <Mapping SourceColumn="user_cp" DataSetColumn="user_cp" />
              <Mapping SourceColumn="user_commune" DataSetColumn="user_commune" />
              <Mapping SourceColumn="user_utmx" DataSetColumn="user_utmx" />
              <Mapping SourceColumn="user_utmy" DataSetColumn="user_utmy" />
              <Mapping SourceColumn="user_tel" DataSetColumn="user_tel" />
              <Mapping SourceColumn="user_mail" DataSetColumn="user_mail" />
              <Mapping SourceColumn="user_videoid" DataSetColumn="user_videoid" />
              <Mapping SourceColumn="user_rem" DataSetColumn="user_rem" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ResaDataSecConnectionString (Web.config)" DbObjectName="dbo.user_detail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCodeP" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByCodeP" GeneratorSourceName="FillByCodeP" GetMethodModifier="Public" GetMethodName="GetDataByCodeP" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByCodeP" UserSourceName="FillByCodeP">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     user_id, user_pwd, user_droit, user_type, user_SAMUref, user_nom, user_prenom, user_adresse, user_cp, user_commune, user_utmx, user_utmy, 
                      user_tel, user_mail, user_videoid, user_rem
FROM         user_detail
WHERE     (user_cp = @cp)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="cp" ColumnName="user_cp" DataSourceName="[C:\INETPUB\WWWROOT\RESASECURITE\APP_DATA\RESADATASEC.MDF].dbo.user_detail" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@cp" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="user_cp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ResaDataSecConnectionString (Web.config)" DbObjectName="dbo.user_detail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCodePEtType" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByCodePEtType" GeneratorSourceName="FillByCodePEtType" GetMethodModifier="Public" GetMethodName="GetDataByCodePEtType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByCodePEtType" UserSourceName="FillByCodePEtType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     user_id, user_pwd, user_droit, user_type, user_SAMUref, user_nom, user_prenom, user_adresse, user_cp, user_commune, user_utmx, user_utmy, 
                      user_tel, user_mail, user_videoid, user_rem
FROM         user_detail
WHERE     (user_cp = @cp) AND (user_type = @type)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="cp" ColumnName="user_cp" DataSourceName="[C:\INETPUB\WWWROOT\RESASECURITE\APP_DATA\RESADATASEC.MDF].dbo.user_detail" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@cp" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="user_cp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="type" ColumnName="user_type" DataSourceName="[C:\INETPUB\WWWROOT\RESASECURITE\APP_DATA\RESADATASEC.MDF].dbo.user_detail" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="user_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ResaDataSecConnectionString (Web.config)" DbObjectName="dbo.user_detail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataById" UserSourceName="FillById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     user_id, user_pwd, user_droit, user_type, user_SAMUref, user_nom, user_prenom, user_adresse, user_cp, user_commune, user_utmx, user_utmy, 
                      user_tel, user_mail, user_videoid, user_rem
FROM         user_detail
WHERE     (user_id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="user_id" DataSourceName="[C:\INETPUB\WWWROOT\RESASECURITE\APP_DATA\RESADATASEC.MDF].dbo.user_detail" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="user_id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ResaDataSecConnectionString (Web.config)" DbObjectName="dbo.user_detail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySAMURef" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBySAMURef" GeneratorSourceName="FillBySAMURef" GetMethodModifier="Public" GetMethodName="GetDataBySAMURef" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBySAMURef" UserSourceName="FillBySAMURef">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     user_id, user_pwd, user_droit, user_type, user_SAMUref, user_nom, user_prenom, user_adresse, user_cp, user_commune, user_utmx, user_utmy, 
                      user_tel, user_mail, user_videoid, user_rem
FROM         user_detail
WHERE     (user_SAMUref = @samu)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="samu" ColumnName="user_SAMUref" DataSourceName="[C:\INETPUB\WWWROOT\RESASECURITE\APP_DATA\RESADATASEC.MDF].dbo.user_detail" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@samu" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="user_SAMUref" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ResaDataSecConnectionString (Web.config)" DbObjectName="dbo.user_detail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTypeDsSamuRef" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByTypeDsSamuRef" GeneratorSourceName="FillByTypeDsSamuRef" GetMethodModifier="Public" GetMethodName="GetDataByTypeDsSamuRef" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByTypeDsSamuRef" UserSourceName="FillByTypeDsSamuRef">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     user_id, user_pwd, user_droit, user_type, user_SAMUref, user_nom, user_prenom, user_adresse, user_cp, user_commune, user_utmx, user_utmy, 
                      user_tel, user_mail, user_videoid, user_rem
FROM         user_detail
WHERE     (user_type = @type) AND (user_SAMUref = @SAMU)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="type" ColumnName="user_type" DataSourceName="[C:\INETPUB\WWWROOT\RESASECURITE\APP_DATA\RESADATASEC.MDF].dbo.user_detail" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="user_type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="SAMU" ColumnName="user_SAMUref" DataSourceName="[C:\INETPUB\WWWROOT\RESASECURITE\APP_DATA\RESADATASEC.MDF].dbo.user_detail" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@SAMU" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="user_SAMUref" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="LogDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="LogDataSet" msprop:Generator_DataSetName="LogDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="user_detail" msprop:Generator_UserTableName="user_detail" msprop:Generator_RowDeletedName="user_detailRowDeleted" msprop:Generator_RowChangedName="user_detailRowChanged" msprop:Generator_RowClassName="user_detailRow" msprop:Generator_RowChangingName="user_detailRowChanging" msprop:Generator_RowEvArgName="user_detailRowChangeEvent" msprop:Generator_RowEvHandlerName="user_detailRowChangeEventHandler" msprop:Generator_TableClassName="user_detailDataTable" msprop:Generator_TableVarName="tableuser_detail" msprop:Generator_RowDeletingName="user_detailRowDeleting" msprop:Generator_TablePropName="user_detail">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="user_id" msprop:Generator_UserColumnName="user_id" msprop:Generator_ColumnPropNameInRow="user_id" msprop:Generator_ColumnVarNameInTable="columnuser_id" msprop:Generator_ColumnPropNameInTable="user_idColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_pwd" msprop:Generator_UserColumnName="user_pwd" msprop:Generator_ColumnPropNameInRow="user_pwd" msprop:Generator_ColumnVarNameInTable="columnuser_pwd" msprop:Generator_ColumnPropNameInTable="user_pwdColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_droit" msprop:Generator_UserColumnName="user_droit" msprop:Generator_ColumnPropNameInRow="user_droit" msprop:Generator_ColumnVarNameInTable="columnuser_droit" msprop:Generator_ColumnPropNameInTable="user_droitColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_type" msprop:Generator_UserColumnName="user_type" msprop:Generator_ColumnPropNameInRow="user_type" msprop:Generator_ColumnVarNameInTable="columnuser_type" msprop:Generator_ColumnPropNameInTable="user_typeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_SAMUref" msprop:Generator_UserColumnName="user_SAMUref" msprop:Generator_ColumnPropNameInRow="user_SAMUref" msprop:Generator_ColumnVarNameInTable="columnuser_SAMUref" msprop:Generator_ColumnPropNameInTable="user_SAMUrefColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_nom" msprop:Generator_UserColumnName="user_nom" msprop:Generator_ColumnPropNameInRow="user_nom" msprop:Generator_ColumnVarNameInTable="columnuser_nom" msprop:Generator_ColumnPropNameInTable="user_nomColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_prenom" msprop:Generator_UserColumnName="user_prenom" msprop:Generator_ColumnPropNameInRow="user_prenom" msprop:Generator_ColumnVarNameInTable="columnuser_prenom" msprop:Generator_ColumnPropNameInTable="user_prenomColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_adresse" msprop:Generator_UserColumnName="user_adresse" msprop:Generator_ColumnPropNameInRow="user_adresse" msprop:Generator_ColumnVarNameInTable="columnuser_adresse" msprop:Generator_ColumnPropNameInTable="user_adresseColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_cp" msprop:Generator_UserColumnName="user_cp" msprop:Generator_ColumnPropNameInRow="user_cp" msprop:Generator_ColumnVarNameInTable="columnuser_cp" msprop:Generator_ColumnPropNameInTable="user_cpColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_commune" msprop:Generator_UserColumnName="user_commune" msprop:Generator_ColumnPropNameInRow="user_commune" msprop:Generator_ColumnVarNameInTable="columnuser_commune" msprop:Generator_ColumnPropNameInTable="user_communeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_utmx" msprop:Generator_UserColumnName="user_utmx" msprop:Generator_ColumnPropNameInRow="user_utmx" msprop:Generator_ColumnVarNameInTable="columnuser_utmx" msprop:Generator_ColumnPropNameInTable="user_utmxColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_utmy" msprop:Generator_UserColumnName="user_utmy" msprop:Generator_ColumnPropNameInRow="user_utmy" msprop:Generator_ColumnVarNameInTable="columnuser_utmy" msprop:Generator_ColumnPropNameInTable="user_utmyColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_tel" msprop:Generator_UserColumnName="user_tel" msprop:Generator_ColumnPropNameInRow="user_tel" msprop:Generator_ColumnVarNameInTable="columnuser_tel" msprop:Generator_ColumnPropNameInTable="user_telColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_mail" msprop:Generator_UserColumnName="user_mail" msprop:Generator_ColumnPropNameInRow="user_mail" msprop:Generator_ColumnVarNameInTable="columnuser_mail" msprop:Generator_ColumnPropNameInTable="user_mailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_videoid" msprop:Generator_UserColumnName="user_videoid" msprop:Generator_ColumnPropNameInRow="user_videoid" msprop:Generator_ColumnVarNameInTable="columnuser_videoid" msprop:Generator_ColumnPropNameInTable="user_videoidColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_rem" msprop:Generator_UserColumnName="user_rem" msprop:Generator_ColumnPropNameInRow="user_rem" msprop:Generator_ColumnVarNameInTable="columnuser_rem" msprop:Generator_ColumnPropNameInTable="user_remColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:user_detail" />
      <xs:field xpath="mstns:user_id" />
    </xs:unique>
  </xs:element>
</xs:schema>